cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Database Support Blog
Options
275

Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server

Jose_Manuel_Jurado on May 30 2024 07:10 AM
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. ...
577

Lesson Learned #496:Verifying Network Route to Azure SQL Database via VPN in Windows

Jose_Manuel_Jurado on May 28 2024 10:17 AM
Today, I worked on a service request where our customer was using a VPN, but the network routes seemed to indicate it wa...
491

Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server

Jose_Manuel_Jurado on May 28 2024 05:15 AM
Today, I worked on a service request where the DNS was providing an incorrect IP address randomly. In this article, I wo...
615

Lesson Learned #494: High number of Executions Plans for a Single Query

Jose_Manuel_Jurado on May 27 2024 09:24 AM
Today, I worked on a service request where our customer detected a high number of execution plans consuming resources in...
623

Lesson Learned #493: Monitoring Application Performance with Server Performance Counters

Jose_Manuel_Jurado on May 24 2024 11:57 AM
Today, I worked on a service request where our customer reported several performance issues in their application connect...
708

Lesson Learned #492: Improving Extended Events in Azure SQL

Jose_Manuel_Jurado on May 22 2024 05:46 AM
In the last months, our Product Team has been working to enhance Extended Events for Azure SQL as you could see in their...
578

Lesson Learned #491: Monitoring Blocking Issues in Azure SQL Database

Jose_Manuel_Jurado on May 21 2024 04:43 AM
Time ago, we wrote an article Lesson Learned #22: How to identify blocking issues? today, I would like to enhance this t...
822

Lesson Learned #490: Monitoring Access from Specific Applications to Azure SQL Database

Jose_Manuel_Jurado on May 18 2024 08:09 AM
This week, I worked on a service request where our customer needed to ensure that specific applications could not connec...
934

Lesson Learned #489:Investigating CPU Spikes with Query Store Overall Resource Consumption Report

Jose_Manuel_Jurado on May 17 2024 01:44 AM
Yesterday, I worked on a customer who experienced a CPU spike that went 90% during the timeframe of 19:00 to 21:00. I wo...
1,038

Lesson Learned #488: A severe error occurred on the current command. Operation cancelled by user.

Jose_Manuel_Jurado on May 16 2024 12:32 AM
Today, I worked on a service request that our customer got this error message: "A severe error occurred on the current c...
1,069

Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database

Jose_Manuel_Jurado on May 15 2024 03:57 AM
Today, I worked on a service request that our customer needs to monitor and optimize queries that can significantly impa...
975

Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement

Jose_Manuel_Jurado on May 14 2024 01:33 AM
Today, we worked on a service request that our customer faced the following error message: Msg 3961, Level 16, State 1, ...
766

Lesson Learned #485: Index Recomendation or the Importance of Index Selection in SQL Server

Jose_Manuel_Jurado on May 13 2024 09:56 AM
Today, I worked on a service request that caught my attention regarding index missing recommendations given by SQL Serve...
908

Lesson Learned #484: Database Performance Monitoring with PowerShell and ReadScale-Out Environments

Jose_Manuel_Jurado on May 10 2024 06:20 AM
Today, I handled a service request from our customer seeking additional information on performance monitoring for ReadSc...
1,731

Lesson Learned #483: Optimizing Performance in Azure SQL Database ReadScale Out Databases

Jose_Manuel_Jurado on May 09 2024 08:02 AM
Today, I worked on a service request that our customer has a Business Critical database with 4 vCores and Read-Scale Out...
1,304

SQL MI Restore with valid SAS key failing with Operating System Error 86

SamGarth on Apr 22 2024 01:39 AM
We will provide details about a workaround for resolving the "Operating System Error 86" encountered during database res...
1,650

Lesson Learned #482: Identifying Potential Duplicate Statistics

Jose_Manuel_Jurado on Apr 01 2024 11:41 AM
Some time ago, we encountered a support case where a customer experienced significant delays in updating auto-created an...
2,010

Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access

Jose_Manuel_Jurado on Mar 30 2024 02:41 PM
In certain circumstances, we need to apply production changes or exclusive access to one or more resources by only one i...
1,537

Lesson Learned #481: Query Performance Analysis Tips

Jose_Manuel_Jurado on Mar 18 2024 08:59 AM
When working with databases, high resource usage or a query reporting a timeout could indicate that the statistics of th...
2,031

Lesson Learned #479:Loading Data from Parquet to Azure SQL Database using C# and SqlBulkCopy

Jose_Manuel_Jurado on Mar 15 2024 12:13 PM
In the realm of big data and cloud computing, efficiently managing and transferring data between different platforms and...
2,913

QTip: Connect to Azure SQL DB using Entra SPN (service principal)

jaigarcimicrosoft on Feb 02 2024 10:54 AM
Connect to Azure SQL DB using Entra SPN

Latest Comments

Roberto_Carrancio
in Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database on May 17 2024 04:35 AM
Hi @Jose_Manuel_Jurado I can see values ​​up to 500 in max_DOP column if I select the sys.dm_exec_query_stats DMV. What does that value represent? Thanks in advance
0 Likes
Devi49
in Azure Data Warehouse Health Check Query on May 14 2024 02:18 PM
I couldn’t see the query used for checking the quick health check. Could you please share it
0 Likes
anoop50
in Lesson Learned #251: Error 40532 using Private Endpoint IP in the server name on Apr 25 2024 01:57 AM
I used this method, but I am still unable to connect using private end point ip and useraname as username@servername to my managed instance. My username looks like email address removed for privacy reasons. Also I able to connect to port 1433 using IP from destination. Please let me know what else i...
0 Likes
saeed_aliakbarian
in Lesson Learned #287: Contains an unresolved reference to an object due to database collation on Apr 20 2024 06:04 AM
In brief the error happens when trying to create a dacpac/bacpac from a database or database project (or build the database project) that has one of the following situations:1. SELECT * : using star(*) in a SELECT statement in a view2. 3 Part names: Including database name when referencing a table (...
0 Likes
SightBeyondSight
in Lesson Learned #482: Identifying Potential Duplicate Statistics on Apr 19 2024 06:02 AM
Great lesson and something one would not even think about.Suggestion to change code @line 21 to :STRING_AGG(CONVERT(VARCHAR(max),sc1.StatisticName),'', '') WITHIN GROUP (ORDER BY sc1.StatisticName) AS StatisticsNames,This will prevent error when the comma delimeted statistics names exceed 8000 chara...
0 Likes